UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+x2Y0QDwHzFT+3HhMIWz3vCx14dDSJmue2pFq5Vfauc='
WHERE
key_id = '0e3abc9e5fb990ba33cadf47850e1be668a2b7dc4a88fc7b2d1006a54c64fb30'
AND (
token = '+x2Y0QDwHzFT+3HhMIWz3vCx14dDSJmue2pFq5Vfauc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)