UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Tp71n9tTRW8FVmK+fMP8RSP4Z4IhvJeKt201CFIkVB8='
WHERE
key_id = '70e93d48f55b8a83e8268a9867aa8127e7b653decf257d70f57f56db9b09f182'
AND (
token = 'Tp71n9tTRW8FVmK+fMP8RSP4Z4IhvJeKt201CFIkVB8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)