UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rqalvCTrCSDUDjkPDEhwUC6cNqhsq5QDsb+gmMJ7iY8='
WHERE
key_id = '787735567721f7924865a87eb5558bdf353032ce0331a83b11006bd1065ec801'
AND (
token = 'rqalvCTrCSDUDjkPDEhwUC6cNqhsq5QDsb+gmMJ7iY8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)