UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NaCcyQ0vRWN/DA2HuB5c/SPB0IdoCMbFRy2IoBhvL/4='
WHERE
key_id = 'b9f8facccf769dd57200c4179ee90b65428708340fb7a4f00c776be0e2a72e61'
AND (
token = 'NaCcyQ0vRWN/DA2HuB5c/SPB0IdoCMbFRy2IoBhvL/4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)