UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BYSFUQAY1KywPPwmM+dDlx9seQIAlTbu730mYPagt3U='
WHERE
key_id = 'd91dd3f4fb238b98c820e4d25dc301b2ff3c1b8caed06ec7b194cd5c1f79899d'
AND (
token = 'BYSFUQAY1KywPPwmM+dDlx9seQIAlTbu730mYPagt3U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)