UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5cZJ6iuONVzr8sCyDoGX7xUXI7RIzM73DAQ+/eHHew8='
WHERE
key_id = 'c4cb21daf807254b4d1873ae6a179b151a83226928f55feac0e18489f59c4fe3'
AND (
token = '5cZJ6iuONVzr8sCyDoGX7xUXI7RIzM73DAQ+/eHHew8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)