UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7dsg/MsWJ8GwrGPaiQXKe5QWkJhnAbLwPaTZcv1j6cs='
WHERE
key_id = '96dd2fc356d96395d793e3bdf5a996070f72a32a58432873c4119cfb6dad1fce'
AND (
token = '7dsg/MsWJ8GwrGPaiQXKe5QWkJhnAbLwPaTZcv1j6cs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)