UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BReuxE4ZDRTNWVAVoM1WlgURHls//7tEG/hsKZDk0Rw='
WHERE
key_id = '9462feb033e6eef29acbe38a04ba90d714ab146d3b8b3705136bc93481e6889e'
AND (
token = 'BReuxE4ZDRTNWVAVoM1WlgURHls//7tEG/hsKZDk0Rw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)