UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HXPl89UokDYPrY+ykO2++5FsjKiEfe5fK2U8TmhygdU='
WHERE
key_id = '78a1c690de20e5f1dc98dd6950f0d833e22ee2b2fb2c7ced83d4b8b89d13e7f4'
AND (
token = 'HXPl89UokDYPrY+ykO2++5FsjKiEfe5fK2U8TmhygdU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)