UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ppE7pO1zPeTDhIjpopKaaE39ifVcC0+1IIpm8JRrkHM='
WHERE
key_id = 'ca963c0918d4acd7872fd267678415c879f015221f09cc1d632ab36fa7223314'
AND (
token = 'ppE7pO1zPeTDhIjpopKaaE39ifVcC0+1IIpm8JRrkHM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)