UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7N6IdOCA/w49MT5rEqoShpEO7dHS5uf7JTtkJ4BsPkM='
WHERE
key_id = '3a9dd7c42c5758d9cc4e7fecd0067f9b588dfec05c57850e36436157ec7eb38d'
AND (
token = '7N6IdOCA/w49MT5rEqoShpEO7dHS5uf7JTtkJ4BsPkM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)