UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'atuRKm2at/ha28SGNmPT9t4HgLoEsHl6gMK/V0F6w4s='
WHERE
key_id = '1d57b2f341f3def6c318f770697ad65f91b4c59826b555342dad2ccb0b875a22'
AND (
token = 'atuRKm2at/ha28SGNmPT9t4HgLoEsHl6gMK/V0F6w4s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)