UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9KONn0hGcGeWA497B8xZbTm0jEd72Q0a3iwS2+d5TmU='
WHERE
key_id = '7328513df4fa125a80e567628ebc93bab7b506bdd2aca9165482331a0939bdfb'
AND (
token = '9KONn0hGcGeWA497B8xZbTm0jEd72Q0a3iwS2+d5TmU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)