UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1c9vCY/i6mw1+0GTfnLAdoQwES90O8A0szMUXOZuZmc='
WHERE
key_id = 'a10b6a56088850d2b37c8ff05439f7fd8b103834a2343abe0e81c05721960c8f'
AND (
token = '1c9vCY/i6mw1+0GTfnLAdoQwES90O8A0szMUXOZuZmc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)