UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iASfxj5MYYaZP2sI3Wf08lAOJWCAyGylxf0mdocVTTg='
WHERE
key_id = 'cfa1443548606a84c87345309745d0e284e13722b225bba4313f7336e2ab20a5'
AND (
token = 'iASfxj5MYYaZP2sI3Wf08lAOJWCAyGylxf0mdocVTTg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)