UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5gjO2vRezBMNWkJq3KWeBlbkMsLYm6QqA/yQciRK3u8='
WHERE
key_id = '203a5ae22bf3f4eb58308758cca642432dcd33af75e1827a4db61c6b33298455'
AND (
token = '5gjO2vRezBMNWkJq3KWeBlbkMsLYm6QqA/yQciRK3u8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)