UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9f0qhJD9wXqZWwj+1azj1dSNejZF0q14SDP0m4tpAEk='
WHERE
key_id = 'e9528ca32b542408ca17083f92fb53a3e5b325452b2f9b36dd4758a4af2a7c06'
AND (
token = '9f0qhJD9wXqZWwj+1azj1dSNejZF0q14SDP0m4tpAEk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)