UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9DrKsdMFvAr9WLDQkomXiR8LkD8zPsiLYdYd0T0TQfQ='
WHERE
key_id = 'd22c4b155748ed0f3a9c7f5226c29c6f37f173ce0621f499d3db802f193c9374'
AND (
token = '9DrKsdMFvAr9WLDQkomXiR8LkD8zPsiLYdYd0T0TQfQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)