UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KnsdhoFH3zBlWTH7PlNvPz/qH9MeuDCiLJlmLgksMa8='
WHERE
key_id = '5c6f8509ba89bf801d38ae6fcf49a91246058d4c0264d441a2a344c615936511'
AND (
token = 'KnsdhoFH3zBlWTH7PlNvPz/qH9MeuDCiLJlmLgksMa8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)