UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J+L9u8sxbz816B2sfK2ic6qZ+xcAoPLxWRyox1VRffg='
WHERE
key_id = 'f792aaa1313fa2d30d3c03b8701ebdd0eb27ae300bf0f0ed55e1de59691ace3e'
AND (
token = 'J+L9u8sxbz816B2sfK2ic6qZ+xcAoPLxWRyox1VRffg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)