UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KD3dGlsq+DrZRZRYQFwLkP7P3uZNYcB9ButYvZ6Q+os='
WHERE
key_id = 'c92dd490fdc031738f129025742277c14cad912fcd8fc112e282046c430e7b84'
AND (
token = 'KD3dGlsq+DrZRZRYQFwLkP7P3uZNYcB9ButYvZ6Q+os='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)