UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UT4wqh8aFb6vi/zrCFQg0h94KDEe3RsN/4QMZ2yzHfM='
WHERE
key_id = '2ce41530942579138e2f93e0437543e086e8df0518f5d7a0430942b04cac5dfa'
AND (
token = 'UT4wqh8aFb6vi/zrCFQg0h94KDEe3RsN/4QMZ2yzHfM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)