UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XpeQkqq8UPYKGuS3PKnUjKSDrl4ATOnX9o/VeWwxaL4='
WHERE
key_id = '14ac0f9064b2230fe2a7eefa1d49d6a90a8d90ced2886ab586ecf6e752ec222c'
AND (
token = 'XpeQkqq8UPYKGuS3PKnUjKSDrl4ATOnX9o/VeWwxaL4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)