UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qgjFn3MF1uX4Izl+qXHoMe7WlsbiOdLUuLnYGTdu2t8='
WHERE
key_id = 'bc5d699df60b22ba62c27e83d2814681941ce1fd243049d2406a504dafcdc2fe'
AND (
token = 'qgjFn3MF1uX4Izl+qXHoMe7WlsbiOdLUuLnYGTdu2t8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)