UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2ZVx+xMhomXwJxzH3v9iw9OzyZ0hEVMczNbQz/zV0Fw='
WHERE
key_id = 'aa9ec54d94665113bc8df20a9b85cf909b633c54027f59bf6aa70fa7b858c36d'
AND (
token = '2ZVx+xMhomXwJxzH3v9iw9OzyZ0hEVMczNbQz/zV0Fw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)