UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jxGNzNWDt2Xsf710oBRBc4Hc+DXsPLCvgNKDlKBB+qg='
WHERE
key_id = 'f46e2a969e221a32c9d1c0da89f8c5218015e31316c1ab580027f359f93fb828'
AND (
token = 'jxGNzNWDt2Xsf710oBRBc4Hc+DXsPLCvgNKDlKBB+qg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)