UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RlPD0wtk+IdhNVdlkEi8ui2Buet3aJo1poXT6s1z6sw='
WHERE
key_id = '0478655058376e88b24f71a61a77513e344d5436de82acdf8a40a7ac439f2e98'
AND (
token = 'RlPD0wtk+IdhNVdlkEi8ui2Buet3aJo1poXT6s1z6sw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)