UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zBq08HfURmY774rYkh66rklJ1g9+hZzeWf6Pw/6uEYQ='
WHERE
key_id = '2b31bb87b8c6a4013bf1a974f7f826dc7bf986faf8c8013669e23a487e2fa481'
AND (
token = 'zBq08HfURmY774rYkh66rklJ1g9+hZzeWf6Pw/6uEYQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)