UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cIZsh8YkcVATDcPKnHl8BI4mrhoDc7p+4ik2a0tVVyc='
WHERE
key_id = 'ff705e36506f603afb1115e3d583a355cb73d1bad66a92dcf186bd3e158622b0'
AND (
token = 'cIZsh8YkcVATDcPKnHl8BI4mrhoDc7p+4ik2a0tVVyc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)