UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bGjlFZlZGfnmcfSywuWt9Afk4OZRJAbINbS2Ne3HEJs='
WHERE
key_id = 'f6a7e30b31e6c5a55ac317cdd355a50600034e0b2d4dfd6da930600ea733c286'
AND (
token = 'bGjlFZlZGfnmcfSywuWt9Afk4OZRJAbINbS2Ne3HEJs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)