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