UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CDyfRAuJpjjhL7bvO5X34m723rBmyqU+n1+eVzdPgEU='
WHERE
key_id = 'c063b6e5a945ef2299a9cb331bc572c49f6ef968b68828574b4e793a5922ceca'
AND (
token = 'CDyfRAuJpjjhL7bvO5X34m723rBmyqU+n1+eVzdPgEU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)