UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5KYHpcqtHLjdsD6oG8GqGxF09/TvK9k9wnD+rsCQ7Ds='
WHERE
key_id = '92f47edc3852d32af42fd4573e0f71584573e719797c69db58a23a00135a2b4c'
AND (
token = '5KYHpcqtHLjdsD6oG8GqGxF09/TvK9k9wnD+rsCQ7Ds='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)