UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pvLA9D6Tfg/RFUnzcfIqnKYYltUi5iETwyis5t0cnbs='
WHERE
key_id = 'ccbd56dd1db4f8a54b24f022ea381aa5d00f85d576620785a1fa246f78c3d13a'
AND (
token = 'pvLA9D6Tfg/RFUnzcfIqnKYYltUi5iETwyis5t0cnbs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)