UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CpmbQ9vapuQcfPUgSjfGB8LMcoO5UjbAE2niuIWM9ic='
WHERE
key_id = 'c0a8c554c1fac764c3c7705e59c5a2b248bae4f5a889d09ea547f4fa7e65aead'
AND (
token = 'CpmbQ9vapuQcfPUgSjfGB8LMcoO5UjbAE2niuIWM9ic='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)