UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zz4kqy3Phlofz1Cm1UXErkyu2neMgzgfzsaRnyLcVWA='
WHERE
key_id = '7260385bfdbfd0e3888fdb1d455a5965cf02d425f1fb14ce6020fa2f4cebc5ca'
AND (
token = 'zz4kqy3Phlofz1Cm1UXErkyu2neMgzgfzsaRnyLcVWA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)