UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'csG6dHReQ8IjYjuDQ9fmcylgbzRBOpBdK055BSFlalM='
WHERE
key_id = 'a6a943defb58c28bb31af0522329ad6eb03235109fc22845ed6b9d4ae1b6c406'
AND (
token = 'csG6dHReQ8IjYjuDQ9fmcylgbzRBOpBdK055BSFlalM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)