UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vU0G0lm0eVp7ajYjOqXrZP3XA4KhQdfVGHhcL4wiG24='
WHERE
key_id = '6b8ca68f9311090a24d0499978f09f83ab8c52bf2bfcb1fd04dea1ca56375293'
AND (
token = 'vU0G0lm0eVp7ajYjOqXrZP3XA4KhQdfVGHhcL4wiG24='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)