UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gNvSszlpUt6IOiCn1jQJtwHE6yNnER1iBclTu3b4dhU='
WHERE
key_id = '2a7ea731911ae618a28a23045cb08b86a739c9bfe00197a0ed642b3a213e8130'
AND (
token = 'gNvSszlpUt6IOiCn1jQJtwHE6yNnER1iBclTu3b4dhU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)