UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KZyrAFpTmF859b1L6UX5LIG/AG1Mx1Pz4Pr5XOrO3R4='
WHERE
key_id = 'c30f2b8f5661f902678b81609239121e8f5003169b491efdd65e7c1fa62ec4f5'
AND (
token = 'KZyrAFpTmF859b1L6UX5LIG/AG1Mx1Pz4Pr5XOrO3R4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)