UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xAf6JZe6+kHUqOjycvYsnpXRvEF9TeUsbgOIVbcNeqU='
WHERE
key_id = 'fccca942a9ec173a25ee2149f72203bedeeade74b23de7d8d9f39f6394f34742'
AND (
token = 'xAf6JZe6+kHUqOjycvYsnpXRvEF9TeUsbgOIVbcNeqU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)