UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'kIGyLODAxbJu4a6fxwwhsxCwtFm9S25CfdO5NsHxwl0=' 
WHERE 
  key_id = '4fc0e7e97b3ca5ee63e2a3e3f103a70c4cbc7b057bba232dbff4d74a4ce8b256' 
  AND (
    token = 'kIGyLODAxbJu4a6fxwwhsxCwtFm9S25CfdO5NsHxwl0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00088