UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R1Gjb8+IiOnm4FUTSseGAr5HlHP/HpHO/bkd4Q4ap04='
WHERE
key_id = 'c3cbd56f585227a9ae3ef16963ded236151c0089483e3bb32c7da4ae392583d9'
AND (
token = 'R1Gjb8+IiOnm4FUTSseGAr5HlHP/HpHO/bkd4Q4ap04='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)