UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w+fNSVpZY5eqT5eYHQDtSGbzirFjMijEzKlRagF/cGs='
WHERE
key_id = 'a04f6702a390df7e0f574e30a27a22d6144cc6933018dd98acf5e09781f7e346'
AND (
token = 'w+fNSVpZY5eqT5eYHQDtSGbzirFjMijEzKlRagF/cGs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)