UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x6p8ZpRTXkGKXBfeKpIccmfheDKUuE/7WzJEFxw4jG0='
WHERE
key_id = '0c62328c9a091a5cb1cab27e371af953b94e3f4dcea015469719822f563a6e3d'
AND (
token = 'x6p8ZpRTXkGKXBfeKpIccmfheDKUuE/7WzJEFxw4jG0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)