UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZdUmOmaPAVmCM2h/43xjenWba7DYVIAl61aSgBphfh0='
WHERE
key_id = '10e9ef9a6747a0c5d760e457c0c9811e4cade53aba4bb2b77e5ea6acd3d23110'
AND (
token = 'ZdUmOmaPAVmCM2h/43xjenWba7DYVIAl61aSgBphfh0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)