UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b42GjA3RJtJTsAl8pfE5gmSdCjPo7drGfyZEPwJN+XQ='
WHERE
key_id = '098fd6d8b96b6147e1ed259e81dba58ee73999354aae556e4c49c922c5d42ee8'
AND (
token = 'b42GjA3RJtJTsAl8pfE5gmSdCjPo7drGfyZEPwJN+XQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)