UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2rHuwa4PxYa6msBjmXdhWFA+lw9oqSp/LdmBuaxAZUw='
WHERE
key_id = '07b010e75c222afe8b4ae14d30496449ee72350e175d521ec150c0ed1ae3d22a'
AND (
token = '2rHuwa4PxYa6msBjmXdhWFA+lw9oqSp/LdmBuaxAZUw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)